Basics
Introduction to MySQL
- What is MySQL?
- Installing and setting up MySQL
- Connecting to MySQL server
Database Fundamentals
- Creating databases and tables
- Basic SQL commands (SELECT, INSERT, UPDATE, DELETE)
- Data types in MySQL
Basic SQL Queries
- Simple SELECT statements
- Filtering data with WHERE clause
- Sorting data with ORDER BY
- Limiting data with LIMIT clause
Intermediate
Advanced SQL Queries
- Joining tables (INNER JOIN, LEFT JOIN, RIGHT JOIN)
- Subqueries and nested queries
- Aggregate functions (COUNT, SUM, AVG, MAX, MIN)
- Grouping data with GROUP BY
Database Design
- Normalization and denormalization
- Primary keys and foreign keys
- Indexing for performance
- ER diagrams and database modeling
Stored Procedures and Functions
- Creating stored procedures
- Creating stored functions
- Using parameters in procedures and functions
- Error handling and exception management
Triggers and Events
- Creating and managing triggers
- Automating tasks with scheduled events
- Applications of triggers and events
Advanced
Performance Optimization
- Query optimization techniques
- Index optimization
- Understanding and using execution plans
- Database caching strategies
Security
- User management and permissions
- Securing connections with SSL
- Data encryption and decryption
- Backup and recovery strategies
Replication and Clustering
- Introduction to replication
- Setting up master-slave replication
- Understanding and using MySQL Cluster
- High availability solutions
Advanced Topics
- JSON data type and functions
- Full-text search
- Spatial data and GIS functions
- Working with large datasets